Database Tuning - A Principled Approach
نویسنده
چکیده
Database tuning is the activity of making a database application run quicker. Tuning is difficult because it requires global knowledge of an information system, from the hardware to the operating system to the query language to the application. Tuning is important because performance can make or break a database application. Achieving higher performance by tuning can save money by eliminating the need to buy new equipment or to develop new software. Features of the text include tuning advice for relational and object-oriented database systems in general, incorporating suggestions from consultants of competing vendors (IBM, Oracle, Sybase, Ingres).
منابع مشابه
Regularized Cost-Model Oblivious Database Tuning with Reinforcement Learning
In this paper, we propose a learning approach to adaptive performance tuning of database applications. The objective is to validate the opportunity to devise a tuning strategy that does not need prior knowledge of a cost model. Instead, the cost model is learned through reinforcement learning. We instantiate our approach to the use case of index tuning. We model the execution of queries and upd...
متن کاملA Monte Carlo-Based Search Strategy for Dimensionality Reduction in Performance Tuning Parameters
Redundant and irrelevant features in high dimensional data increase the complexity in underlying mathematical models. It is necessary to conduct pre-processing steps that search for the most relevant features in order to reduce the dimensionality of the data. This study made use of a meta-heuristic search approach which uses lightweight random simulations to balance between the exploitation of ...
متن کاملAdaptive Tuning of Model Predictive Control Parameters based on Analytical Results
In dealing with model predictive controllers (MPC), controller tuning is a key design step. Various tuning methods are proposed in the literature which can be categorized as heuristic, numerical and analytical methods. Among the available tuning methods, analytical approaches are more interesting and useful. This paper is based on a proposed analytical MPC tuning approach for plants can be appr...
متن کاملUPnQ: An Architecture for Personal Information Exploration
Today our lives are being mapped to the binary realm provided by computing devices and their interconnections. The constant increase in both amount and diversity of personal information organized in digital files already turned into an information overload. User files contain an ever augmenting quantity of potential information that can be extracted at a non-negligible processing cost. In this ...
متن کاملOracle Database Workload Performance Measurement and Tuning Toolkit
Database tuning practice is mainly conducted as a consequence of user’s complaints on the performance. There is a need for a reactive monitoring and tuning tool enabling a real-time overview of the main resource consumers in order to detect and solve performance bottlenecks. With an assessment of the Oracle’s high-availability database, in terms of the main architectural components and their im...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 1992